package cn.gson.fengboot.model.dao;

import cn.gson.fengboot.model.pojos.Lxsmbcb;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface LxsmbcbDao extends CrudRepository<Lxsmbcb,Integer> {

    @Query(nativeQuery = true,value = "SELECT * FROM lxsmbcb e LEFT JOIN qemp_from f ON e.emp_id = f.emp_id WHERE  f.emp_name =?1 ")
    public List<String> qq(String Type);
}
